Integration and dimensional modeling approaches for complex data warehousing
Identifieur interne : 000641 ( Main/Exploration ); précédent : 000640; suivant : 000642Integration and dimensional modeling approaches for complex data warehousing
Auteurs : O. Boussaid [France] ; Adrian Tanasescu [France] ; Fadila Bentayeb [France] ; Jérôme Darmont [France]Source :
- Journal of Global Optimization [ 0925-5001 ] ; 2007-04-01.
English descriptors
- KwdEn :
Abstract
Abstract: With the broad development of the World Wide Web, various kinds of heterogeneous data (including multimedia data) are now available to decision support tasks. A data warehousing approach is often adopted to prepare data for relevant analysis. Data integration and dimensional modeling indeed allow the creation of appropriate analysis contexts. However, the existing data warehousing tools are well-suited to classical, numerical data. They cannot handle complex data. In our approach, we adapt the three main phases of the data warehousing process to complex data. In this paper, we particularly focus on two main steps in complex data warehousing. The first step is data integration. We define a generic UML model that helps representing a wide range of complex data, including their possible semantic properties. Complex data are then stored in XML documents generated by a piece of software we designed. The second important phase we address is the preparation of data for dimensional modeling. We propose an approach that exploits data mining techniques to assist users in building relevant dimensional models.
Url:
DOI: 10.1007/s10898-006-9064-6
Affiliations:
Links toward previous steps (curation, corpus...)
- to stream Istex, to step Corpus: 002228
- to stream Istex, to step Curation: 001B03
- to stream Istex, to step Checkpoint: 000589
- to stream Main, to step Merge: 000647
- to stream Main, to step Curation: 000641
Le document en format XML
<record><TEI wicri:istexFullTextTei="biblStruct"><teiHeader><fileDesc><titleStmt><title xml:lang="en">Integration and dimensional modeling approaches for complex data warehousing</title>
<author><name sortKey="Boussaid, O" sort="Boussaid, O" uniqKey="Boussaid O" first="O." last="Boussaid">O. Boussaid</name>
</author>
<author><name sortKey="Tanasescu, Adrian" sort="Tanasescu, Adrian" uniqKey="Tanasescu A" first="Adrian" last="Tanasescu">Adrian Tanasescu</name>
</author>
<author><name sortKey="Bentayeb, Fadila" sort="Bentayeb, Fadila" uniqKey="Bentayeb F" first="Fadila" last="Bentayeb">Fadila Bentayeb</name>
</author>
<author><name sortKey="Darmont, Jerome" sort="Darmont, Jerome" uniqKey="Darmont J" first="Jérôme" last="Darmont">Jérôme Darmont</name>
</author>
</titleStmt>
<publicationStmt><idno type="wicri:source">ISTEX</idno>
<idno type="RBID">ISTEX:84B285DCC35289D43AB4DDC8E8800745F0C50E89</idno>
<date when="2006" year="2006">2006</date>
<idno type="doi">10.1007/s10898-006-9064-6</idno>
<idno type="url">https://api.istex.fr/ark:/67375/VQC-BRHKX0J8-C/fulltext.pdf</idno>
<idno type="wicri:Area/Istex/Corpus">002228</idno>
<idno type="wicri:explorRef" wicri:stream="Istex" wicri:step="Corpus" wicri:corpus="ISTEX">002228</idno>
<idno type="wicri:Area/Istex/Curation">001B03</idno>
<idno type="wicri:Area/Istex/Checkpoint">000589</idno>
<idno type="wicri:explorRef" wicri:stream="Istex" wicri:step="Checkpoint">000589</idno>
<idno type="wicri:doubleKey">0925-5001:2006:Boussaid O:integration:and:dimensional</idno>
<idno type="wicri:Area/Main/Merge">000647</idno>
<idno type="wicri:Area/Main/Curation">000641</idno>
<idno type="wicri:Area/Main/Exploration">000641</idno>
</publicationStmt>
<sourceDesc><biblStruct><analytic><title level="a" type="main" xml:lang="en">Integration and dimensional modeling approaches for complex data warehousing</title>
<author><name sortKey="Boussaid, O" sort="Boussaid, O" uniqKey="Boussaid O" first="O." last="Boussaid">O. Boussaid</name>
<affiliation wicri:level="3"><country xml:lang="fr">France</country>
<wicri:regionArea>ERIC, Université Lumière Lyon2, 5 avenue Pierre-Mendès-France, 69676, Bron Cedex</wicri:regionArea>
<placeName><region type="region" nuts="2">Auvergne-Rhône-Alpes</region>
<region type="old region" nuts="2">Rhône-Alpes</region>
<settlement type="city">Bron</settlement>
</placeName>
</affiliation>
<affiliation wicri:level="1"><country wicri:rule="url">France</country>
</affiliation>
</author>
<author><name sortKey="Tanasescu, Adrian" sort="Tanasescu, Adrian" uniqKey="Tanasescu A" first="Adrian" last="Tanasescu">Adrian Tanasescu</name>
<affiliation wicri:level="4"><country xml:lang="fr">France</country>
<wicri:regionArea>LIRIS, Université Claude Bernard Lyon 1, 43 boulevard. du 11 novembre 1918, 69422, Villeurbanne Cedex</wicri:regionArea>
<placeName><region type="region" nuts="2">Auvergne-Rhône-Alpes</region>
<region type="old region" nuts="2">Rhône-Alpes</region>
<settlement type="city">Villeurbanne</settlement>
</placeName>
<orgName type="university">Université Claude Bernard Lyon 1</orgName>
</affiliation>
<affiliation wicri:level="1"><country wicri:rule="url">France</country>
</affiliation>
</author>
<author><name sortKey="Bentayeb, Fadila" sort="Bentayeb, Fadila" uniqKey="Bentayeb F" first="Fadila" last="Bentayeb">Fadila Bentayeb</name>
<affiliation wicri:level="3"><country xml:lang="fr">France</country>
<wicri:regionArea>ERIC, Université Lumière Lyon2, 5 avenue Pierre-Mendès-France, 69676, Bron Cedex</wicri:regionArea>
<placeName><region type="region" nuts="2">Auvergne-Rhône-Alpes</region>
<region type="old region" nuts="2">Rhône-Alpes</region>
<settlement type="city">Bron</settlement>
</placeName>
</affiliation>
<affiliation wicri:level="1"><country wicri:rule="url">France</country>
</affiliation>
</author>
<author><name sortKey="Darmont, Jerome" sort="Darmont, Jerome" uniqKey="Darmont J" first="Jérôme" last="Darmont">Jérôme Darmont</name>
<affiliation wicri:level="3"><country xml:lang="fr">France</country>
<wicri:regionArea>ERIC, Université Lumière Lyon2, 5 avenue Pierre-Mendès-France, 69676, Bron Cedex</wicri:regionArea>
<placeName><region type="region" nuts="2">Auvergne-Rhône-Alpes</region>
<region type="old region" nuts="2">Rhône-Alpes</region>
<settlement type="city">Bron</settlement>
</placeName>
</affiliation>
<affiliation wicri:level="1"><country wicri:rule="url">France</country>
</affiliation>
</author>
</analytic>
<monogr></monogr>
<series><title level="j">Journal of Global Optimization</title>
<title level="j" type="sub">An International Journal Dealing with Theoretical and Computational Aspects of Seeking Global Optima and Their Applications in Science, Management and Engineering</title>
<title level="j" type="abbrev">J Glob Optim</title>
<idno type="ISSN">0925-5001</idno>
<idno type="eISSN">1573-2916</idno>
<imprint><publisher>Kluwer Academic Publishers-Plenum Publishers; http://www.springer-ny.com</publisher>
<pubPlace>New York</pubPlace>
<date type="published" when="2007-04-01">2007-04-01</date>
<biblScope unit="volume">37</biblScope>
<biblScope unit="issue">4</biblScope>
<biblScope unit="page" from="571">571</biblScope>
<biblScope unit="page" to="591">591</biblScope>
</imprint>
<idno type="ISSN">0925-5001</idno>
</series>
</biblStruct>
</sourceDesc>
<seriesStmt><idno type="ISSN">0925-5001</idno>
</seriesStmt>
</fileDesc>
<profileDesc><textClass><keywords scheme="KwdEn" xml:lang="en"><term>Complex data</term>
<term>Data integration</term>
<term>Data mining</term>
<term>Data preparation</term>
<term>Data warehousing</term>
<term>Dimensional modeling</term>
</keywords>
</textClass>
<langUsage><language ident="en">en</language>
</langUsage>
</profileDesc>
</teiHeader>
<front><div type="abstract" xml:lang="en">Abstract: With the broad development of the World Wide Web, various kinds of heterogeneous data (including multimedia data) are now available to decision support tasks. A data warehousing approach is often adopted to prepare data for relevant analysis. Data integration and dimensional modeling indeed allow the creation of appropriate analysis contexts. However, the existing data warehousing tools are well-suited to classical, numerical data. They cannot handle complex data. In our approach, we adapt the three main phases of the data warehousing process to complex data. In this paper, we particularly focus on two main steps in complex data warehousing. The first step is data integration. We define a generic UML model that helps representing a wide range of complex data, including their possible semantic properties. Complex data are then stored in XML documents generated by a piece of software we designed. The second important phase we address is the preparation of data for dimensional modeling. We propose an approach that exploits data mining techniques to assist users in building relevant dimensional models.</div>
</front>
</TEI>
<affiliations><list><country><li>France</li>
</country>
<region><li>Auvergne-Rhône-Alpes</li>
<li>Rhône-Alpes</li>
</region>
<settlement><li>Bron</li>
<li>Villeurbanne</li>
</settlement>
<orgName><li>Université Claude Bernard Lyon 1</li>
</orgName>
</list>
<tree><country name="France"><region name="Auvergne-Rhône-Alpes"><name sortKey="Boussaid, O" sort="Boussaid, O" uniqKey="Boussaid O" first="O." last="Boussaid">O. Boussaid</name>
</region>
<name sortKey="Bentayeb, Fadila" sort="Bentayeb, Fadila" uniqKey="Bentayeb F" first="Fadila" last="Bentayeb">Fadila Bentayeb</name>
<name sortKey="Bentayeb, Fadila" sort="Bentayeb, Fadila" uniqKey="Bentayeb F" first="Fadila" last="Bentayeb">Fadila Bentayeb</name>
<name sortKey="Boussaid, O" sort="Boussaid, O" uniqKey="Boussaid O" first="O." last="Boussaid">O. Boussaid</name>
<name sortKey="Darmont, Jerome" sort="Darmont, Jerome" uniqKey="Darmont J" first="Jérôme" last="Darmont">Jérôme Darmont</name>
<name sortKey="Darmont, Jerome" sort="Darmont, Jerome" uniqKey="Darmont J" first="Jérôme" last="Darmont">Jérôme Darmont</name>
<name sortKey="Tanasescu, Adrian" sort="Tanasescu, Adrian" uniqKey="Tanasescu A" first="Adrian" last="Tanasescu">Adrian Tanasescu</name>
<name sortKey="Tanasescu, Adrian" sort="Tanasescu, Adrian" uniqKey="Tanasescu A" first="Adrian" last="Tanasescu">Adrian Tanasescu</name>
</country>
</tree>
</affiliations>
</record>
Pour manipuler ce document sous Unix (Dilib)
EXPLOR_STEP=$WICRI_ROOT/Wicri/Informatique/explor/SgmlV1/Data/Main/Exploration
HfdSelect -h $EXPLOR_STEP/biblio.hfd -nk 000641 | SxmlIndent | more
Ou
HfdSelect -h $EXPLOR_AREA/Data/Main/Exploration/biblio.hfd -nk 000641 | SxmlIndent | more
Pour mettre un lien sur cette page dans le réseau Wicri
{{Explor lien |wiki= Wicri/Informatique |area= SgmlV1 |flux= Main |étape= Exploration |type= RBID |clé= ISTEX:84B285DCC35289D43AB4DDC8E8800745F0C50E89 |texte= Integration and dimensional modeling approaches for complex data warehousing }}
This area was generated with Dilib version V0.6.33. |